Set Cell Color

Command Prototype

Excel.SetCellColor(objExcelWorkBook,sheet,strCell,listColor,bSave)

Command Description

Set the color of the specified cell, the parameter is an rgb array, such as [r,g,b]

Parameter Description
Required Parameter
objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel))
sheet--If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0)
strCell--The specified cell, supports two forms: cell names (such as "A1") or array of rows and columns (such as [row number, column number]). When using cell names, it is case insensitive
listColor--Color in RGB array format
bSave--Save immediately after an operation

results matching ""

    No results matching ""